﻿<%@ Page Title="" Language="C#" MasterPageFile="~/AppCode/MasterPages/Admin.master" AutoEventWireup="true" CodeFile="Report.aspx.cs" Inherits="Report_Report" %>

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
    <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="1055px">
        <LocalReport ReportPath="AppCode\Report\Report1.rdlc">
            <DataSources>
                <rsweb:ReportDataSource DataSourceId="SqlDataSource2" Name="DataSet1" />
            </DataSources>
        </LocalReport>
    </rsweb:ReportViewer>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:Health_InsuranceConnectionString %>" SelectCommand="SELECT EmpRegister.Empno, EmpRegister.UserName, Policies.PolicyId, Policies.PolicyName, CompanyDetails.CompanyName, PoliciesOnEmployees.PStartDate, PoliciesOnEmployees.PEndDate FROM PoliciesOnEmployees INNER JOIN Policies ON PoliciesOnEmployees.PolicyId = Policies.PolicyId INNER JOIN CompanyDetails ON CompanyDetails.CompanyId = Policies.CompanyId INNER JOIN EmpRegister ON PoliciesOnEmployees.Empno = EmpRegister.Empno"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Health_InsuranceConnectionString3 %>" SelectCommand="SELECT * FROM [PolicyTotalDescription]"></asp:SqlDataSource>
</asp:Content>

